-
as seen on SQL Blog
- Search for 'SQL Blog'
Part 1 of this series was an introduction and overview of Hyper-V Dynamic Memory. This part looks at SQL Server memory management and how the SQL engine responds to changing OS memory conditions.
Part 2: SQL Server Memory Management
As with any Windows process, sqlserver.exe has a virtual…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
SQL and Dynamic Memory Blog Post Series
Hyper-V Dynamic Memory is a new feature in Windows Server 2008 R2 SP1 that allows the memory assigned to guest virtual machines to vary according to demand. Using this feature with SQL Server is supported, but how well does it work in…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
SQL and Dynamic Memory Blog Post Series
Hyper-V Dynamic Memory is a new feature in Windows Server 2008 R2 SP1 that allows the memory assigned to guest virtual machines to vary according to demand. Using this feature with SQL Server is supported, but how well does it work in…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Dear everyone,
I have successfully debugged my own memory leak problems. However, I have noticed some very strange occurence.
for fid, fv in freqDic.iteritems():
outf.write(fid+"\t") #ID
for i, term in enumerate(domain): #Vector
tfidf = self.tf(term…
>>> More
-
as seen on SQL Blog
- Search for 'SQL Blog'
In parts 1 and 2 of this series we looked at the basics of Hyper-V Dynamic Memory and SQL Server memory management. In this part Serdar looks at configuration guidelines for SQL Server memory management.
Part 3: Configuration Guidelines for Hyper-V Dynamic Memory and SQL Server
Now that…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Hi,
My new server has 2 x X5570 CPUs.
Now here is the output of grep -i hz /proc/cpuinfo
model name : Intel(R) Xeon(R) CPU X5570 @ 2.93GHz
cpu MHz : 1600.231
model name : Intel(R) Xeon(R) CPU X5570 @ 2.93GHz
cpu MHz : 1600.231
model name : Intel(R) Xeon(R) CPU …
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Hello!
I'm running FreeBSD 7.2 under VMware ESXi 3.5. Host has 2 physical CPUs and the BSD box is currently the only running VM. Only one virtual CPU is assigned to the VM.
When measuring CPU time of a specific program, I get very different results from time to time. Processor usage is reported…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
According to http://net-snmp.sourceforge.net/docs/mibs/ucdavis.html#scalar_notcurrent ssCpuUser, ssCpuSystem, ssCpuIdle, etc are deprecated in favor of the raw variants (ssCpuRawUser, etc).
The former values (which don't cover things like nice, wait, kernel, interrupt, etc) returned a percentage…
>>> More
-
as seen on Super User
- Search for 'Super User'
I've noticed that there are sometimes (large) differences between the reported total CPU usage and a summation of the per-process CPU utilization given by apps like top and wmtop.
As an example: I recently ran a git filter-branch --index-filter on a fairly large repo, with the index-filter command…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I have a Ubuntu 12.04 server which sometimes dies completely - no SSH, no ping, nothing until it is physically rebooted.
After the reboot, I see in syslog that the oom-killer killed, well, pretty much everything.
There's a lot of detailed memory usage information in them. How do I read these logs…
>>> More